/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package ru.miit.elearning.servlets.pages;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.hibernate.Session;
import ru.miit.elearning.hibernate.dao.CourseDAO;
import ru.miit.elearning.hibernate.dao.HibernateUtil;
import ru.miit.elearning.hibernate.dto.UserIdentity;

/**
 *
 * @author Cyclone
 */
public class SignStudentsServlet extends HttpServlet {

    /**
     * Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        //request.setCharacterEncoding("UTF-8");
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        String message = null;


        Session session = null;


        try {

            Integer courseId = Integer.parseInt(request.getParameter("courseId"));

            session = HibernateUtil.getSessionFactory().getCurrentSession();
            session.beginTransaction();

            CourseDAO courseDAO = new CourseDAO(session);
            String courseTitle = "";
            try {
                courseTitle = courseDAO.findCourseTitle(courseId);
            } catch (Exception e) {
                e.printStackTrace();
            }

            List<UserIdentity> userIdentityDelList = null;
            try {
                userIdentityDelList = courseDAO.findStudentsByCourse(courseId);
            } catch (Exception e) {
                e.printStackTrace();
            }

            List<UserIdentity> userIdentityAddList = null;
            try {
                userIdentityAddList = courseDAO.findStudentsByNoCourse(courseId);
            } catch (Exception e) {
                e.printStackTrace();
            }



            request.setAttribute("courseTitle", courseTitle);
            request.setAttribute("courseId", courseId);
            if (userIdentityDelList != null) {
                request.setAttribute("userDelList", userIdentityDelList);
            }
            if (userIdentityAddList != null) {
                request.setAttribute("userAddList", userIdentityAddList);
            }

            getServletContext().getRequestDispatcher("/signStudents.jsp").forward(request, response);
            if (session != null && session.isOpen()) {
                session.getTransaction().commit();
            }
        } catch (Exception e) {
            Logger.getLogger(SignStudentsServlet.class.getName()).log(Level.SEVERE, null, e);
            if (session != null && session.isOpen()) {
                session.getTransaction().rollback();
            }

            message = "Ошибка запроса списка студентов курса";
            e.printStackTrace();

            getServletContext().setAttribute("message", message);
            getServletContext().getRequestDispatcher("/signStudents.jsp").forward(request, response);

        } finally {
            out.close();

            if (session != null && session.isOpen()) {
                session.close();
            }

        }
    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
